Dataset info
| Number of variables | 111 |
|---|---|
| Number of observations | 5627 |
| Missing cells | 320754 (51.4%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 4.8 MiB |
| Average record size in memory | 888.0 B |
Variables types
| Numeric | 17 |
|---|---|
| Categorical | 20 |
| Boolean | 3 |
| Date | 0 |
| URL | 1 |
| Text (Unique) | 0 |
| Rejected | 70 |
| Unsupported | 0 |
Warnings
acc_now_delinq has constant value "0" | Rejected |
acc_open_past_24mths has constant value "None" | Rejected |
all_util has constant value "None" | Rejected |
annual_inc_joint has constant value "None" | Rejected |
application_type has constant value "INDIVIDUAL" | Rejected |
avg_cur_bal has constant value "None" | Rejected |
bc_open_to_buy has constant value "None" | Rejected |
bc_util has constant value "None" | Rejected |
collection_recovery_fee has 1845 (32.8%) zeros | Zeros |
delinq_2yrs has 4936 (87.7%) zeros | Zeros |
delinq_amnt has constant value "0" | Rejected |
desc has a high cardinality: 3798 distinct values | Warning |
desc has 1802 (32.0%) missing values | Missing |
dti_joint has constant value "None" | Rejected |
earliest_cr_line has a high cardinality: 421 distinct values | Warning |
emp_length has 228 (4.1%) missing values | Missing |
emp_title has a high cardinality: 4637 distinct values | Warning |
emp_title has 484 (8.6%) missing values | Missing |
funded_amnt_inv is highly correlated with funded_amnt (ρ = 0.9269962876) | Rejected |
il_util has constant value "None" | Rejected |
initial_list_status has constant value "f" | Rejected |
inq_fi has constant value "None" | Rejected |
inq_last_12m has constant value "None" | Rejected |
inq_last_6mths has 2280 (40.5%) zeros | Zeros |
installment is highly correlated with funded_amnt (ρ = 0.9538261179) | Rejected |
int_rate has a high cardinality: 332 distinct values | Warning |
issue_d has a high cardinality: 53 distinct values | Warning |
last_credit_pull_d has a high cardinality: 84 distinct values | Warning |
last_pymnt_amnt has 71 (1.3%) zeros | Zeros |
last_pymnt_d has a high cardinality: 98 distinct values | Warning |
last_pymnt_d has 71 (1.3%) missing values | Missing |
loan_amnt is highly correlated with installment (ρ = 0.9259114356) | Rejected |
loan_status has constant value "Charged Off" | Rejected |
max_bal_bc has constant value "None" | Rejected |
member_id is highly correlated with id (ρ = 0.9941924448) | Rejected |
mo_sin_old_il_acct has constant value "None" | Rejected |
mo_sin_old_rev_tl_op has constant value "None" | Rejected |
mo_sin_rcnt_rev_tl_op has constant value "None" | Rejected |
mo_sin_rcnt_tl has constant value "None" | Rejected |
mort_acc has constant value "None" | Rejected |
mths_since_last_delinq has 67 (1.2%) zeros | Zeros |
mths_since_last_delinq has 3485 (61.9%) missing values | Missing |
mths_since_last_major_derog has constant value "None" | Rejected |
mths_since_last_record has 111 (2.0%) zeros | Zeros |
mths_since_last_record has 5049 (89.7%) missing values | Missing |
mths_since_rcnt_il has constant value "None" | Rejected |
mths_since_recent_bc has constant value "None" | Rejected |
mths_since_recent_bc_dlq has constant value "None" | Rejected |
mths_since_recent_inq has constant value "None" | Rejected |
mths_since_recent_revol_delinq has constant value "None" | Rejected |
next_pymnt_d has constant value "None" | Rejected |
num_accts_ever_120_pd has constant value "None" | Rejected |
num_actv_bc_tl has constant value "None" | Rejected |
num_actv_rev_tl has constant value "None" | Rejected |
num_bc_sats has constant value "None" | Rejected |
num_bc_tl has constant value "None" | Rejected |
num_il_tl has constant value "None" | Rejected |
num_op_rev_tl has constant value "None" | Rejected |
num_rev_accts has constant value "None" | Rejected |
num_rev_tl_bal_gt_0 has constant value "None" | Rejected |
num_sats has constant value "None" | Rejected |
num_tl_120dpd_2m has constant value "None" | Rejected |
num_tl_30dpd has constant value "None" | Rejected |
num_tl_90g_dpd_24m has constant value "None" | Rejected |
num_tl_op_past_12m has constant value "None" | Rejected |
open_acc_6m has constant value "None" | Rejected |
open_il_12m has constant value "None" | Rejected |
open_il_24m has constant value "None" | Rejected |
open_il_6m has constant value "None" | Rejected |
open_rv_12m has constant value "None" | Rejected |
open_rv_24m has constant value "None" | Rejected |
out_prncp has constant value "0.0" | Rejected |
out_prncp_inv has constant value "0.0" | Rejected |
pct_tl_nvr_dlq has constant value "None" | Rejected |
percent_bc_gt_75 has constant value "None" | Rejected |
policy_code has constant value "1" | Rejected |
pub_rec_bankruptcies has 118 (2.1%) missing values | Missing |
pymnt_plan has constant value "n" | Rejected |
recoveries has 1409 (25.0%) zeros | Zeros |
revol_bal has 158 (2.8%) zeros | Zeros |
revol_util has a high cardinality: 1000 distinct values | Warning |
title has a high cardinality: 3250 distinct values | Warning |
tot_coll_amt has constant value "None" | Rejected |
tot_cur_bal has constant value "None" | Rejected |
tot_hi_cred_lim has constant value "None" | Rejected |
total_bal_ex_mort has constant value "None" | Rejected |
total_bal_il has constant value "None" | Rejected |
total_bc_limit has constant value "None" | Rejected |
total_cu_tl has constant value "None" | Rejected |
total_il_high_credit_limit has constant value "None" | Rejected |
total_pymnt_inv is highly correlated with total_pymnt (ρ = 0.9680389296) | Rejected |
total_rec_int has 71 (1.3%) zeros | Zeros |
total_rec_late_fee has 4764 (84.7%) zeros | Zeros |
total_rec_prncp is highly correlated with total_pymnt (ρ = 0.9149544526) | Rejected |
total_rev_hi_lim has constant value "None" | Rejected |
verification_status_joint has constant value "None" | Rejected |
zip_code has a high cardinality: 666 distinct values | Warning |
acc_now_delinq
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
acc_open_past_24mths
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
addr_state
Categorical
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CA | |
|---|---|
| FL | 504 |
| NY | 495 |
| Other values (44) |
| Value | Count | Frequency (%) | |
| CA | 1125 | 20.0% | |
| FL | 504 | 9.0% | |
| NY | 495 | 8.8% | |
| TX | 316 | 5.6% | |
| NJ | 278 | 4.9% | |
| GA | 215 | 3.8% | |
| IL | 197 | 3.5% | |
| PA | 180 | 3.2% | |
| VA | 177 | 3.1% | |
| MD | 162 | 2.9% | |
| Other values (37) | 1978 | 35.2% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
all_util
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
annual_inc
Numeric
| Distinct count | 1253 |
|---|---|
| Unique (%) | 22.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 62427.29803 |
|---|---|
| Minimum | 4080 |
| Maximum | 1250000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4080 |
|---|---|
| 5-th percentile | 21600 |
| Q1 | 37000 |
| Median | 53000 |
| Q3 | 75000 |
| 95-th percentile | 129697.2 |
| Maximum | 1250000 |
| Range | 1245920 |
| Interquartile range | 38000 |
Descriptive statistics
| Standard deviation | 47776.01419 |
|---|---|
| Coef of variation | 0.7653064555 |
| Kurtosis | 119.3739852 |
| Mean | 62427.29803 |
| MAD | 27283.50303 |
| Skewness | 7.543335189 |
| Sum | 351278406 |
| Variance | 2282547532 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 4080. 9006. 11720. 12120. 14202. ... 198502. 200500. 252308. 392000. 1250000.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 60000 | 256 | 4.5% | |
| 50000 | 164 | 2.9% | |
| 40000 | 156 | 2.8% | |
| 30000 | 139 | 2.5% | |
| 36000 | 131 | 2.3% | |
| 45000 | 126 | 2.2% | |
| 75000 | 109 | 1.9% | |
| 48000 | 108 | 1.9% | |
| 65000 | 102 | 1.8% | |
| 70000 | 102 | 1.8% | |
| Other values (1243) | 4234 | 75.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4080 | 1 | < 0.1% | |
| 4800 | 1 | < 0.1% | |
| 6000 | 2 | < 0.1% | |
| 8000 | 2 | < 0.1% | |
| 8412 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1250000 | 1 | < 0.1% | |
| 840000 | 1 | < 0.1% | |
| 780000 | 1 | < 0.1% | |
| 700053.85 | 1 | < 0.1% | |
| 700000 | 1 | < 0.1% |
annual_inc_joint
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
application_type
Constant
This variable is constant and should be ignored for analysis
| Constant value | INDIVIDUAL |
|---|
avg_cur_bal
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
bc_open_to_buy
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
bc_util
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
chargeoff_within_12_mths
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 6 |
| 0 | |
|---|---|
| (Missing) | 6 |
| Value | Count | Frequency (%) | |
| 0 | 5621 | 99.9% | |
| (Missing) | 6 | 0.1% |
collection_recovery_fee
Numeric
| Distinct count | 2616 |
|---|---|
| Unique (%) | 46.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 87.56594031 |
|---|---|
| Minimum | 0 |
| Maximum | 7002.19 |
| Zeros (%) | 32.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2.5132 |
| Q3 | 9.365 |
| 95-th percentile | 448.5852 |
| Maximum | 7002.19 |
| Range | 7002.19 |
| Interquartile range | 9.365 |
Descriptive statistics
| Standard deviation | 386.5906054 |
|---|---|
| Coef of variation | 4.4148513 |
| Kurtosis | 116.802426 |
| Mean | 87.56594031 |
| MAD | 141.9203755 |
| Skewness | 9.462006471 |
| Sum | 492733.5461 |
| Variance | 149452.2962 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.00000000e+00 3.15000000e-02 1.96550000e-01 4.35000000e-01 1.19945000e+00 ... 6.39413950e+02 1.09218500e+03 1.61554500e+03 2.84658095e+03 7.00219000e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 1845 | 32.8% | |
| 2 | 12 | 0.2% | |
| 1.2 | 10 | 0.2% | |
| 3.71 | 9 | 0.2% | |
| 1.21 | 8 | 0.1% | |
| 0.8 | 8 | 0.1% | |
| 1.6 | 8 | 0.1% | |
| 1.88 | 8 | 0.1% | |
| 1.69 | 8 | 0.1% | |
| 2.02 | 8 | 0.1% | |
| Other values (2606) | 3703 | 65.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1845 | 32.8% | |
| 0.063 | 1 | < 0.1% | |
| 0.074500001 | 1 | < 0.1% | |
| 0.134799995 | 1 | < 0.1% | |
| 0.1393 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7002.19 | 1 | < 0.1% | |
| 6972.59 | 1 | < 0.1% | |
| 6543.04 | 1 | < 0.1% | |
| 5774.8 | 1 | < 0.1% | |
| 5602.72 | 1 | < 0.1% |
collections_12_mths_ex_med
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 6 |
| 0 | |
|---|---|
| (Missing) | 6 |
| Value | Count | Frequency (%) | |
| 0 | 5621 | 99.9% | |
| (Missing) | 6 | 0.1% |
delinq_2yrs
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1706060068 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 87.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.5349861096 |
|---|---|
| Coef of variation | 3.13579879 |
| Kurtosis | 30.57652144 |
| Mean | 0.1706060068 |
| MAD | 0.2993109114 |
| Skewness | 4.549698424 |
| Sum | 960 |
| Variance | 0.2862101375 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=9)
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 8. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 4936 | 87.7% | |
| 1 | 507 | 9.0% | |
| 2 | 130 | 2.3% | |
| 3 | 35 | 0.6% | |
| 4 | 13 | 0.2% | |
| 5 | 3 | 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4936 | 87.7% | |
| 1 | 507 | 9.0% | |
| 2 | 130 | 2.3% | |
| 3 | 35 | 0.6% | |
| 4 | 13 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 3 | 0.1% | |
| 4 | 13 | 0.2% |
delinq_amnt
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
desc
Categorical
| Distinct count | 3798 |
|---|---|
| Unique (%) | 67.5% |
| Missing (%) | 32.0% |
| Missing (n) | 1802 |
| 26 | |
| Debt Consolidation | 4 |
| Borrower added on 12/20/10 > I will be using part of the funds to pay off some higher interst credit cards / medical bills so I can cancel those accounts. I also will use the rest to help finish my basement so we can rent it out for the time being, and increase the value of our home in the long run.<br/> | 1 |
| Other values (3794) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 26 | 0.5% | ||
| Debt Consolidation | 4 | 0.1% | |
| Borrower added on 12/20/10 > I will be using part of the funds to pay off some higher interst credit cards / medical bills so I can cancel those accounts. I also will use the rest to help finish my basement so we can rent it out for the time being, and increase the value of our home in the long run.<br/> | 1 | < 0.1% | |
| I would like to pay off the following three credit card balances: Chase Visa Card - Balance = $1,268.76 @ 28.99% Discover Card - Balance = $6,097.63 @ 15.9% Wal-Mart Discover Card Balance = $6,790.93 @ 14.99% Borrower added on 02/23/11 > The Discover Card (balance of $6097.63) has been paid in full and was listed by mistake. Can't figure out how to remove it from the listing description.<br/><br/>The following is correct:<br/><br/>I would like to pay off the following three credit card balances:<br/><br/>Chase Visa Card - Balance = $1,268.76 @ 28.99%<br/>Wal-Mart Discover Card Balance = $6,790.93 @ 14.99%<br/> | 1 | < 0.1% | |
| Borrower added on 05/04/11 > I have always been a responsible borrower. No late payments, no defaults, no deliquencies. The reason for this loan is debt consolodation. With this loan, I will actually REDUCE my current debt payments by 65% paying off ALL my other short-term, revolving debt. I have a stable income and career in a Fortune-500 company, and have been working there for 3 years, receiving 2 promotions since being hired.<br/> | 1 | < 0.1% | |
| Borrower added on 09/28/10 > We are using this money for our wedding in November. I've never missed a payment on a bill or been late. We plan to put all of the money we receive at our wedding towards this loan.<br/> | 1 | < 0.1% | |
| 576099 added on 11/19/09 > Thank you for this opportunity. As you can see by my crdit report, paying my bills in a timely manner is very important to me. With this loan I will be able to free up some money for me to be able to save as well.<br/> | 1 | < 0.1% | |
| Borrower added on 04/07/11 > My wife and I will be using this loan towards two months of rent for our house. Once this loan is recieved and used it will be paid off in full.<br/> | 1 | < 0.1% | |
| Borrower added on 09/01/11 > I want the loan to pay my out of pocket expenses on recent medical bills accrued so insurance will pay at 100% and I wont have to make monthly payments to all the doctors etc...<br/> | 1 | < 0.1% | |
| I'm currently deployed to Iraq and wanting to use the loan to purchase this motorcycle as a gift for my wife. $2600.00 will be used to purchase the bike and $400.00 will be used to purchase protective posture gear | 1 | < 0.1% | |
| Other values (3787) | 3787 | 67.3% | |
| (Missing) | 1802 | 32.0% |
| Max length | 3986 |
|---|---|
| Mean length | 295.3621823 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
dti
Numeric
| Distinct count | 2219 |
|---|---|
| Unique (%) | 39.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14.00062378 |
|---|---|
| Minimum | 0 |
| Maximum | 29.85 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.433 |
| Q1 | 9.05 |
| Median | 14.29 |
| Q3 | 19.29 |
| 95-th percentile | 23.92 |
| Maximum | 29.85 |
| Range | 29.85 |
| Interquartile range | 10.24 |
Descriptive statistics
| Standard deviation | 6.585577045 |
|---|---|
| Coef of variation | 0.4703774024 |
| Kurtosis | -0.8174755921 |
| Mean | 14.00062378 |
| MAD | 5.504844427 |
| Skewness | -0.1725850535 |
| Sum | 78781.51 |
| Variance | 43.36982501 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-03 2.2500e-01 3.7850e+00 7.6650e+00 1.1625e+01 2.0705e+01 2.4895e+01 2.6255e+01 2.9850e+01], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 29 | 0.5% | |
| 18 | 13 | 0.2% | |
| 9.6 | 9 | 0.2% | |
| 9.5 | 9 | 0.2% | |
| 19.2 | 9 | 0.2% | |
| 19.9 | 9 | 0.2% | |
| 12.48 | 9 | 0.2% | |
| 14.97 | 8 | 0.1% | |
| 13.5 | 8 | 0.1% | |
| 14 | 8 | 0.1% | |
| Other values (2209) | 5516 | 98.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 29 | 0.5% | |
| 0.01 | 1 | < 0.1% | |
| 0.08 | 1 | < 0.1% | |
| 0.13 | 1 | < 0.1% | |
| 0.14 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 29.85 | 1 | < 0.1% | |
| 29.62 | 1 | < 0.1% | |
| 29.6 | 1 | < 0.1% | |
| 29.58 | 1 | < 0.1% | |
| 29.45 | 1 | < 0.1% |
dti_joint
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
earliest_cr_line
Categorical
| Distinct count | 421 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Nov-98 | 58 |
|---|---|
| Apr-00 | 57 |
| Jan-00 | 55 |
| Other values (418) |
| Value | Count | Frequency (%) | |
| Nov-98 | 58 | 1.0% | |
| Apr-00 | 57 | 1.0% | |
| Jan-00 | 55 | 1.0% | |
| Dec-97 | 52 | 0.9% | |
| Nov-99 | 49 | 0.9% | |
| Jan-01 | 48 | 0.9% | |
| Dec-00 | 47 | 0.8% | |
| Oct-00 | 47 | 0.8% | |
| Dec-98 | 47 | 0.8% | |
| Aug-98 | 43 | 0.8% | |
| Other values (411) | 5124 | 91.1% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
emp_length
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 4.1% |
| Missing (n) | 228 |
| 10+ years | |
|---|---|
| < 1 year | |
| 2 years | 567 |
| Other values (8) |
| Value | Count | Frequency (%) | |
| 10+ years | 1331 | 23.7% | |
| < 1 year | 639 | 11.4% | |
| 2 years | 567 | 10.1% | |
| 3 years | 555 | 9.9% | |
| 4 years | 462 | 8.2% | |
| 5 years | 458 | 8.1% | |
| 1 year | 456 | 8.1% | |
| 6 years | 307 | 5.5% | |
| 7 years | 263 | 4.7% | |
| 8 years | 203 | 3.6% | |
| (Missing) | 228 | 4.1% |
| Max length | 9 |
|---|---|
| Mean length | 7.38404123 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
emp_title
Categorical
| Distinct count | 4637 |
|---|---|
| Unique (%) | 82.4% |
| Missing (%) | 8.6% |
| Missing (n) | 484 |
| Bank of America | 20 |
|---|---|
| US Army | 18 |
| Walmart | 14 |
| Other values (4633) | |
| (Missing) | 484 |
| Value | Count | Frequency (%) | |
| Bank of America | 20 | 0.4% | |
| US Army | 18 | 0.3% | |
| Walmart | 14 | 0.2% | |
| AT&T | 12 | 0.2% | |
| UPS | 12 | 0.2% | |
| IBM | 9 | 0.2% | |
| Kaiser Permanente | 8 | 0.1% | |
| U.S. Army | 8 | 0.1% | |
| Target | 7 | 0.1% | |
| US Postal Service | 7 | 0.1% | |
| Other values (4626) | 5028 | 89.4% | |
| (Missing) | 484 | 8.6% |
| Max length | 57 |
|---|---|
| Mean length | 17.02612404 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
funded_amnt
Numeric
| Distinct count | 618 |
|---|---|
| Unique (%) | 11.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11753.39879 |
|---|---|
| Minimum | 900 |
| Maximum | 35000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 900 |
|---|---|
| 5-th percentile | 2315 |
| Q1 | 5575 |
| Median | 10000 |
| Q3 | 16000 |
| 95-th percentile | 25000 |
| Maximum | 35000 |
| Range | 34100 |
| Interquartile range | 10425 |
Descriptive statistics
| Standard deviation | 7760.516335 |
|---|---|
| Coef of variation | 0.6602784839 |
| Kurtosis | 0.4815292272 |
| Mean | 11753.39879 |
| MAD | 6228.940875 |
| Skewness | 0.951077569 |
| Sum | 66136375 |
| Variance | 60225613.78 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 900. 950. 1025. 1150. 1225. ... 28037.5 29850. 30112.5 34837.5 35000. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 10000 | 348 | 6.2% | |
| 12000 | 294 | 5.2% | |
| 5000 | 287 | 5.1% | |
| 15000 | 242 | 4.3% | |
| 6000 | 211 | 3.7% | |
| 8000 | 209 | 3.7% | |
| 20000 | 205 | 3.6% | |
| 25000 | 201 | 3.6% | |
| 4000 | 148 | 2.6% | |
| 7000 | 129 | 2.3% | |
| Other values (608) | 3353 | 59.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 900 | 1 | < 0.1% | |
| 1000 | 47 | 0.8% | |
| 1050 | 1 | < 0.1% | |
| 1100 | 1 | < 0.1% | |
| 1200 | 21 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 35000 | 126 | 2.2% | |
| 34675 | 1 | < 0.1% | |
| 34475 | 1 | < 0.1% | |
| 34000 | 2 | < 0.1% | |
| 33950 | 2 | < 0.1% |
funded_amnt_inv
Highly correlated
This variable is highly correlated with funded_amnt and should be ignored for analysis
| Correlation | 0.9269962876 |
|---|
grade
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B | |
|---|---|
| C | |
| D | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| B | 1425 | 25.3% | |
| C | 1347 | 23.9% | |
| D | 1118 | 19.9% | |
| E | 715 | 12.7% | |
| A | 602 | 10.7% | |
| F | 319 | 5.7% | |
| G | 101 | 1.8% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
home_ownership
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| RENT | |
|---|---|
| MORTGAGE | |
| OWN | 443 |
| Value | Count | Frequency (%) | |
| RENT | 2839 | 50.5% | |
| MORTGAGE | 2327 | 41.4% | |
| OWN | 443 | 7.9% | |
| OTHER | 18 | 0.3% |
| Max length | 8 |
|---|---|
| Mean length | 5.578638706 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
id
Numeric
| Distinct count | 5627 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 697844.0142 |
|---|---|
| Minimum | 61419 |
| Maximum | 1077430 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61419 |
|---|---|
| 5-th percentile | 366924.4 |
| Q1 | 529724.5 |
| Median | 696937 |
| Q3 | 854876 |
| 95-th percentile | 1047346.5 |
| Maximum | 1077430 |
| Range | 1016011 |
| Interquartile range | 325151.5 |
Descriptive statistics
| Standard deviation | 216376.6767 |
|---|---|
| Coef of variation | 0.3100645306 |
| Kurtosis | -0.7567488199 |
| Mean | 697844.0142 |
| MAD | 181345.8045 |
| Skewness | -0.03097370761 |
| Sum | 3926768268 |
| Variance | 4.681886621e+10 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 61419. 115851. 346934.5 439318.5 665852. ... 894398.5 965662.5 1031038. 1069728.5 1077430. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 968703 | 1 | < 0.1% | |
| 287875 | 1 | < 0.1% | |
| 428387 | 1 | < 0.1% | |
| 545435 | 1 | < 0.1% | |
| 797340 | 1 | < 0.1% | |
| 990688 | 1 | < 0.1% | |
| 582305 | 1 | < 0.1% | |
| 621218 | 1 | < 0.1% | |
| 654859 | 1 | < 0.1% | |
| 891558 | 1 | < 0.1% | |
| Other values (5617) | 5617 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61419 | 1 | < 0.1% | |
| 65426 | 1 | < 0.1% | |
| 111227 | 1 | < 0.1% | |
| 113179 | 1 | < 0.1% | |
| 118523 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1077430 | 1 | < 0.1% | |
| 1071795 | 1 | < 0.1% | |
| 1071570 | 1 | < 0.1% | |
| 1069800 | 1 | < 0.1% | |
| 1069657 | 1 | < 0.1% |
il_util
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
initial_list_status
Constant
This variable is constant and should be ignored for analysis
| Constant value | f |
|---|
inq_fi
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
inq_last_12m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
inq_last_6mths
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.058112671 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 40.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.154135761 |
|---|---|
| Coef of variation | 1.0907494 |
| Kurtosis | 2.208996775 |
| Mean | 1.058112671 |
| MAD | 0.8921101259 |
| Skewness | 1.233563198 |
| Sum | 5954 |
| Variance | 1.332029356 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=9)
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5.5 8. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 2280 | 40.5% | |
| 1 | 1677 | 29.8% | |
| 2 | 943 | 16.8% | |
| 3 | 619 | 11.0% | |
| 4 | 51 | 0.9% | |
| 5 | 28 | 0.5% | |
| 6 | 16 | 0.3% | |
| 7 | 10 | 0.2% | |
| 8 | 3 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2280 | 40.5% | |
| 1 | 1677 | 29.8% | |
| 2 | 943 | 16.8% | |
| 3 | 619 | 11.0% | |
| 4 | 51 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 3 | 0.1% | |
| 7 | 10 | 0.2% | |
| 6 | 16 | 0.3% | |
| 5 | 28 | 0.5% | |
| 4 | 51 | 0.9% |
installment
Highly correlated
This variable is highly correlated with funded_amnt and should be ignored for analysis
| Correlation | 0.9538261179 |
|---|
int_rate
Categorical
| Distinct count | 332 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 11.49% | 127 |
|---|---|
| 13.49% | 127 |
| 10.99% | 95 |
| Other values (329) |
| Value | Count | Frequency (%) | |
| 11.49% | 127 | 2.3% | |
| 13.49% | 127 | 2.3% | |
| 10.99% | 95 | 1.7% | |
| 11.71% | 91 | 1.6% | |
| 11.99% | 76 | 1.4% | |
| 14.27% | 74 | 1.3% | |
| 12.69% | 72 | 1.3% | |
| 16.77% | 71 | 1.3% | |
| 12.99% | 69 | 1.2% | |
| 18.25% | 62 | 1.1% | |
| Other values (322) | 4763 | 84.6% |
| Max length | 6 |
|---|---|
| Mean length | 5.858006042 |
| Min length | 5 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
issue_d
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Dec-11 | 423 |
|---|---|
| Nov-11 | 335 |
| Oct-11 | 308 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| Dec-11 | 423 | 7.5% | |
| Nov-11 | 335 | 6.0% | |
| Oct-11 | 308 | 5.5% | |
| Sep-11 | 307 | 5.5% | |
| May-11 | 289 | 5.1% | |
| Jul-11 | 278 | 4.9% | |
| Aug-11 | 267 | 4.7% | |
| Jun-11 | 267 | 4.7% | |
| Apr-11 | 221 | 3.9% | |
| Mar-11 | 207 | 3.7% | |
| Other values (43) | 2725 | 48.4% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
last_credit_pull_d
Categorical
| Distinct count | 84 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| May-16 | |
|---|---|
| Apr-16 | 319 |
| Feb-13 | 172 |
| Other values (80) |
| Value | Count | Frequency (%) | |
| May-16 | 1991 | 35.4% | |
| Apr-16 | 319 | 5.7% | |
| Feb-13 | 172 | 3.1% | |
| Mar-13 | 104 | 1.8% | |
| Nov-12 | 97 | 1.7% | |
| Dec-12 | 96 | 1.7% | |
| Aug-12 | 94 | 1.7% | |
| Nov-13 | 83 | 1.5% | |
| Apr-13 | 82 | 1.5% | |
| May-13 | 80 | 1.4% | |
| Other values (73) | 2508 | 44.6% |
| Max length | 6 |
|---|---|
| Mean length | 5.999644571 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
last_pymnt_amnt
Numeric
| Distinct count | 4591 |
|---|---|
| Unique (%) | 81.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 326.0208335 |
|---|---|
| Minimum | 0 |
| Maximum | 12818.38 |
| Zeros (%) | 1.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30.82 |
| Q1 | 112.885 |
| Median | 238.25 |
| Q3 | 405.705 |
| 95-th percentile | 822.423 |
| Maximum | 12818.38 |
| Range | 12818.38 |
| Interquartile range | 292.82 |
Descriptive statistics
| Standard deviation | 528.9830514 |
|---|---|
| Coef of variation | 1.622543706 |
| Kurtosis | 256.0566538 |
| Mean | 326.0208335 |
| MAD | 222.5705381 |
| Skewness | 13.5788541 |
| Sum | 1834519.23 |
| Variance | 279823.0687 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-03 2.500000e-02 2.500500e+01 3.579000e+01 ... 8.886400e+02 9.830200e+02 1.340680e+03 2.053485e+03 1.281838e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 71 | 1.3% | |
| 200 | 16 | 0.3% | |
| 100 | 15 | 0.3% | |
| 50 | 15 | 0.3% | |
| 400 | 12 | 0.2% | |
| 150 | 10 | 0.2% | |
| 500 | 10 | 0.2% | |
| 276.06 | 9 | 0.2% | |
| 250 | 8 | 0.1% | |
| 324.42 | 8 | 0.1% | |
| Other values (4581) | 5453 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 71 | 1.3% | |
| 0.01 | 1 | < 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 1 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12818.38 | 1 | < 0.1% | |
| 12390.99 | 1 | < 0.1% | |
| 11800 | 1 | < 0.1% | |
| 11328.71 | 1 | < 0.1% | |
| 10021.06 | 1 | < 0.1% |
last_pymnt_d
Categorical
| Distinct count | 98 |
|---|---|
| Unique (%) | 1.7% |
| Missing (%) | 1.3% |
| Missing (n) | 71 |
| Oct-12 | 177 |
|---|---|
| Jul-12 | 164 |
| Jun-12 | 151 |
| Other values (94) |
| Value | Count | Frequency (%) | |
| Oct-12 | 177 | 3.1% | |
| Jul-12 | 164 | 2.9% | |
| Jun-12 | 151 | 2.7% | |
| Aug-12 | 150 | 2.7% | |
| Feb-12 | 148 | 2.6% | |
| Mar-12 | 137 | 2.4% | |
| Nov-12 | 131 | 2.3% | |
| Dec-11 | 129 | 2.3% | |
| May-12 | 129 | 2.3% | |
| Sep-12 | 127 | 2.3% | |
| Other values (87) | 4113 | 73.1% |
| Max length | 6 |
|---|---|
| Mean length | 5.974764528 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
loan_amnt
Highly correlated
This variable is highly correlated with installment and should be ignored for analysis
| Correlation | 0.9259114356 |
|---|
loan_status
Constant
This variable is constant and should be ignored for analysis
| Constant value | Charged Off |
|---|
max_bal_bc
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
member_id
Highly correlated
This variable is highly correlated with id and should be ignored for analysis
| Correlation | 0.9941924448 |
|---|
mo_sin_old_il_acct
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mo_sin_old_rev_tl_op
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mo_sin_rcnt_rev_tl_op
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mo_sin_rcnt_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mort_acc
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_last_delinq
Numeric
| Distinct count | 87 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 61.9% |
| Missing (n) | 3485 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 36.1573296 |
|---|---|
| Minimum | 0 |
| Maximum | 107 |
| Zeros (%) | 1.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 17 |
| Median | 34 |
| Q3 | 53 |
| 95-th percentile | 76 |
| Maximum | 107 |
| Range | 107 |
| Interquartile range | 36 |
Descriptive statistics
| Standard deviation | 22.67933338 |
|---|---|
| Coef of variation | 0.6272402755 |
| Kurtosis | -0.932111251 |
| Mean | 36.1573296 |
| MAD | 19.2506702 |
| Skewness | 0.3009613847 |
| Sum | 77449 |
| Variance | 514.3521625 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 67 | 1.2% | |
| 19 | 52 | 0.9% | |
| 15 | 46 | 0.8% | |
| 21 | 40 | 0.7% | |
| 25 | 38 | 0.7% | |
| 30 | 37 | 0.7% | |
| 23 | 37 | 0.7% | |
| 16 | 37 | 0.7% | |
| 24 | 36 | 0.6% | |
| 39 | 36 | 0.6% | |
| Other values (76) | 1716 | 30.5% | |
| (Missing) | 3485 | 61.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 67 | 1.2% | |
| 1 | 6 | 0.1% | |
| 2 | 17 | 0.3% | |
| 3 | 20 | 0.4% | |
| 4 | 25 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 107 | 1 | < 0.1% | |
| 97 | 1 | < 0.1% | |
| 83 | 2 | < 0.1% | |
| 82 | 13 | 0.2% | |
| 81 | 16 | 0.3% |
mths_since_last_major_derog
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_last_record
Numeric
| Distinct count | 89 |
|---|---|
| Unique (%) | 1.6% |
| Missing (%) | 89.7% |
| Missing (n) | 5049 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 74.6799308 |
|---|---|
| Minimum | 0 |
| Maximum | 129 |
| Zeros (%) | 2.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 53.25 |
| Median | 92 |
| Q3 | 105 |
| 95-th percentile | 115.15 |
| Maximum | 129 |
| Range | 129 |
| Interquartile range | 51.75 |
Descriptive statistics
| Standard deviation | 41.25836478 |
|---|---|
| Coef of variation | 0.5524692422 |
| Kurtosis | -0.6351109417 |
| Mean | 74.6799308 |
| MAD | 34.57352043 |
| Skewness | -0.9677994262 |
| Sum | 43165 |
| Variance | 1702.252664 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 111 | 2.0% | |
| 111 | 19 | 0.3% | |
| 94 | 15 | 0.3% | |
| 89 | 15 | 0.3% | |
| 87 | 14 | 0.2% | |
| 113 | 13 | 0.2% | |
| 104 | 12 | 0.2% | |
| 100 | 12 | 0.2% | |
| 88 | 12 | 0.2% | |
| 114 | 12 | 0.2% | |
| Other values (78) | 343 | 6.1% | |
| (Missing) | 5049 | 89.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 111 | 2.0% | |
| 7 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 129 | 1 | < 0.1% | |
| 119 | 2 | < 0.1% | |
| 118 | 9 | 0.2% | |
| 117 | 7 | 0.1% | |
| 116 | 10 | 0.2% |
mths_since_rcnt_il
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_recent_bc
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_recent_bc_dlq
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_recent_inq
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
mths_since_recent_revol_delinq
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
next_pymnt_d
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_accts_ever_120_pd
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_actv_bc_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_actv_rev_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_bc_sats
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_bc_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_il_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_op_rev_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_rev_accts
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_rev_tl_bal_gt_0
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_sats
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_tl_120dpd_2m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_tl_30dpd
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_tl_90g_dpd_24m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
num_tl_op_past_12m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_acc
Numeric
| Distinct count | 34 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.17807002 |
|---|---|
| Minimum | 2 |
| Maximum | 38 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| Median | 8 |
| Q3 | 12 |
| 95-th percentile | 18 |
| Maximum | 38 |
| Range | 36 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 4.525936902 |
|---|---|
| Coef of variation | 0.4931251224 |
| Kurtosis | 2.01528432 |
| Mean | 9.17807002 |
| MAD | 3.497564502 |
| Skewness | 1.073728831 |
| Sum | 51645 |
| Variance | 20.48410484 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=34)
Histogram with variable size bins (bins=[ 2. 3.5 5.5 9.5 11.5 ... 17.5 19.5 21.5 28.5 38. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 7 | 557 | 9.9% | |
| 8 | 546 | 9.7% | |
| 6 | 543 | 9.6% | |
| 9 | 518 | 9.2% | |
| 10 | 465 | 8.3% | |
| 5 | 425 | 7.6% | |
| 11 | 382 | 6.8% | |
| 4 | 364 | 6.5% | |
| 12 | 301 | 5.3% | |
| 13 | 263 | 4.7% | |
| Other values (24) | 1263 | 22.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 127 | 2.3% | |
| 3 | 258 | 4.6% | |
| 4 | 364 | 6.5% | |
| 5 | 425 | 7.6% | |
| 6 | 543 | 9.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 38 | 1 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 34 | 1 | < 0.1% | |
| 33 | 2 | < 0.1% | |
| 31 | 3 | 0.1% |
open_acc_6m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_il_12m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_il_24m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_il_6m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_rv_12m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
open_rv_24m
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
out_prncp
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
out_prncp_inv
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
pct_tl_nvr_dlq
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
percent_bc_gt_75
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
policy_code
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
pub_rec
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 457 |
| 2 | 10 |
| Value | Count | Frequency (%) | |
| 0 | 5160 | 91.7% | |
| 1 | 457 | 8.1% | |
| 2 | 10 | 0.2% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
pub_rec_bankruptcies
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 2.1% |
| Missing (n) | 118 |
| 0 | |
|---|---|
| 1 | 366 |
| 2 | 2 |
| (Missing) | 118 |
| Value | Count | Frequency (%) | |
| 0 | 5141 | 91.4% | |
| 1 | 366 | 6.5% | |
| 2 | 2 | < 0.1% | |
| (Missing) | 118 | 2.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
purpose
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| debt_consolidation | |
|---|---|
| other | |
| credit_card | 542 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| debt_consolidation | 2767 | 49.2% | |
| other | 633 | 11.2% | |
| credit_card | 542 | 9.6% | |
| small_business | 475 | 8.4% | |
| home_improvement | 347 | 6.2% | |
| major_purchase | 222 | 3.9% | |
| car | 160 | 2.8% | |
| medical | 106 | 1.9% | |
| wedding | 96 | 1.7% | |
| moving | 92 | 1.6% | |
| Other values (4) | 187 | 3.3% |
| Max length | 18 |
|---|---|
| Mean length | 13.92002843 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
pymnt_plan
Constant
This variable is constant and should be ignored for analysis
| Constant value | n |
|---|
recoveries
Numeric
| Distinct count | 4040 |
|---|---|
| Unique (%) | 71.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 672.1018723 |
|---|---|
| Minimum | 0 |
| Maximum | 29623.35 |
| Zeros (%) | 25.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 173.04 |
| Q3 | 595.655 |
| 95-th percentile | 2889.824 |
| Maximum | 29623.35 |
| Range | 29623.35 |
| Interquartile range | 595.655 |
Descriptive statistics
| Standard deviation | 1720.742949 |
|---|---|
| Coef of variation | 2.560241267 |
| Kurtosis | 57.01836553 |
| Mean | 672.1018723 |
| MAD | 805.2963287 |
| Skewness | 6.437516221 |
| Sum | 3781917.235 |
| Variance | 2960956.297 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.0000000e+00 3.1500000e+00 8.2750000e+00 9.3950000e+00 1.7830000e+01 ... 2.6624150e+03 4.0404500e+03 8.0348650e+03 1.6531375e+04 2.9623350e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 1409 | 25.0% | |
| 10.4 | 4 | 0.1% | |
| 11.29 | 4 | 0.1% | |
| 19.2 | 3 | 0.1% | |
| 9.8 | 3 | 0.1% | |
| 13.44 | 3 | 0.1% | |
| 14.61 | 3 | 0.1% | |
| 13.93 | 3 | 0.1% | |
| 10.13 | 3 | 0.1% | |
| 16.27 | 3 | 0.1% | |
| Other values (4030) | 4189 | 74.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1409 | 25.0% | |
| 6.3 | 1 | < 0.1% | |
| 6.31 | 1 | < 0.1% | |
| 8.19 | 1 | < 0.1% | |
| 8.36 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 29623.35 | 1 | < 0.1% | |
| 22943.37 | 1 | < 0.1% | |
| 21810.31 | 1 | < 0.1% | |
| 20006.53 | 1 | < 0.1% | |
| 19915.67 | 1 | < 0.1% |
revol_bal
Numeric
| Distinct count | 4942 |
|---|---|
| Unique (%) | 87.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13514.24365 |
|---|---|
| Minimum | 0 |
| Maximum | 148829 |
| Zeros (%) | 2.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 330.5 |
| Q1 | 3968 |
| Median | 9211 |
| Q3 | 17518 |
| 95-th percentile | 41681 |
| Maximum | 148829 |
| Range | 148829 |
| Interquartile range | 13550 |
Descriptive statistics
| Standard deviation | 15164.11747 |
|---|---|
| Coef of variation | 1.122084067 |
| Kurtosis | 13.77170652 |
| Mean | 13514.24365 |
| MAD | 10078.29157 |
| Skewness | 2.980029559 |
| Sum | 76044649 |
| Variance | 229950458.8 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 1.50000e+01 9.82500e+02 9.07200e+03 ... 3.67065e+04 4.96135e+04 5.88585e+04 1.07680e+05 1.48829e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 158 | 2.8% | |
| 12028 | 4 | 0.1% | |
| 981 | 4 | 0.1% | |
| 6548 | 3 | 0.1% | |
| 980 | 3 | 0.1% | |
| 8546 | 3 | 0.1% | |
| 2823 | 3 | 0.1% | |
| 900 | 3 | 0.1% | |
| 4485 | 3 | 0.1% | |
| 11 | 3 | 0.1% | |
| Other values (4932) | 5440 | 96.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 158 | 2.8% | |
| 1 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 148829 | 1 | < 0.1% | |
| 147365 | 1 | < 0.1% | |
| 141165 | 1 | < 0.1% | |
| 137112 | 2 | < 0.1% | |
| 136456 | 1 | < 0.1% |
revol_util
Categorical
| Distinct count | 1000 |
|---|---|
| Unique (%) | 17.8% |
| Missing (%) | 0.3% |
| Missing (n) | 16 |
| 0% | 144 |
|---|---|
| 66.60% | 17 |
| 73.40% | 15 |
| Other values (996) | |
| (Missing) | 16 |
| Value | Count | Frequency (%) | |
| 0% | 144 | 2.6% | |
| 66.60% | 17 | 0.3% | |
| 73.40% | 15 | 0.3% | |
| 63.70% | 15 | 0.3% | |
| 89.40% | 15 | 0.3% | |
| 77.60% | 14 | 0.2% | |
| 45.10% | 14 | 0.2% | |
| 80.60% | 14 | 0.2% | |
| 66.70% | 14 | 0.2% | |
| 66.30% | 14 | 0.2% | |
| Other values (989) | 5335 | 94.8% | |
| (Missing) | 16 | 0.3% |
| Max length | 6 |
|---|---|
| Mean length | 5.555891239 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
sub_grade
Categorical
| Distinct count | 35 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B5 | 356 |
|---|---|
| B3 | 341 |
| C1 | 336 |
| Other values (32) |
| Value | Count | Frequency (%) | |
| B5 | 356 | 6.3% | |
| B3 | 341 | 6.1% | |
| C1 | 336 | 6.0% | |
| B4 | 329 | 5.8% | |
| C2 | 321 | 5.7% | |
| D2 | 271 | 4.8% | |
| C3 | 270 | 4.8% | |
| D3 | 256 | 4.5% | |
| B2 | 228 | 4.1% | |
| A5 | 217 | 3.9% | |
| Other values (25) | 2702 | 48.0% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
tax_liens
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| 0 | |
|---|---|
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| 0 | 5626 | > 99.9% | |
| (Missing) | 1 | < 0.1% |
term
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 36 months | |
|---|---|
| 60 months |
| Value | Count | Frequency (%) | |
| 36 months | 3227 | 57.3% | |
| 60 months | 2400 | 42.7% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
title
Categorical
| Distinct count | 3250 |
|---|---|
| Unique (%) | 57.8% |
| Missing (%) | < 0.1% |
| Missing (n) | 2 |
| Debt Consolidation | 305 |
|---|---|
| Debt Consolidation Loan | 274 |
| Personal Loan | 97 |
| Other values (3246) |
| Value | Count | Frequency (%) | |
| Debt Consolidation | 305 | 5.4% | |
| Debt Consolidation Loan | 274 | 4.9% | |
| Personal Loan | 97 | 1.7% | |
| debt consolidation | 95 | 1.7% | |
| Small Business Loan | 95 | 1.7% | |
| Debt consolidation | 60 | 1.1% | |
| Consolidation | 57 | 1.0% | |
| Personal | 56 | 1.0% | |
| Home Improvement | 50 | 0.9% | |
| personal | 46 | 0.8% | |
| Other values (3239) | 4490 | 79.8% |
| Max length | 79 |
|---|---|
| Mean length | 16.7272081 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
tot_coll_amt
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
tot_cur_bal
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
tot_hi_cred_lim
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_acc
Numeric
| Distinct count | 65 |
|---|---|
| Unique (%) | 1.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.4275813 |
|---|---|
| Minimum | 2 |
| Maximum | 74 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 13 |
| Median | 20 |
| Q3 | 28 |
| 95-th percentile | 43 |
| Maximum | 74 |
| Range | 72 |
| Interquartile range | 15 |
Descriptive statistics
| Standard deviation | 11.44742724 |
|---|---|
| Coef of variation | 0.534237956 |
| Kurtosis | 0.5171527331 |
| Mean | 21.4275813 |
| MAD | 9.192819699 |
| Skewness | 0.8088224086 |
| Sum | 120573 |
| Variance | 131.0435904 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 2. 2.5 3.5 6.5 9.5 ... 36.5 43.5 49.5 64.5 74. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 14 | 231 | 4.1% | |
| 16 | 223 | 4.0% | |
| 17 | 205 | 3.6% | |
| 15 | 200 | 3.6% | |
| 11 | 198 | 3.5% | |
| 12 | 197 | 3.5% | |
| 19 | 195 | 3.5% | |
| 13 | 194 | 3.4% | |
| 10 | 187 | 3.3% | |
| 18 | 187 | 3.3% | |
| Other values (55) | 3610 | 64.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 42 | 0.7% | |
| 4 | 79 | 1.4% | |
| 5 | 91 | 1.6% | |
| 6 | 107 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 74 | 1 | < 0.1% | |
| 70 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% | |
| 63 | 11 | 0.2% | |
| 62 | 6 | 0.1% |
total_bal_ex_mort
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_bal_il
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_bc_limit
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_cu_tl
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_il_high_credit_limit
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
total_pymnt
Numeric
| Distinct count | 5598 |
|---|---|
| Unique (%) | 99.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6838.030941 |
|---|---|
| Minimum | 0 |
| Maximum | 51745.45 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 572.92 |
| Q1 | 2215.575 |
| Median | 4839 |
| Q3 | 9191.705 |
| 95-th percentile | 20385.237 |
| Maximum | 51745.45 |
| Range | 51745.45 |
| Interquartile range | 6976.13 |
Descriptive statistics
| Standard deviation | 6615.858854 |
|---|---|
| Coef of variation | 0.9675093475 |
| Kurtosis | 4.922080801 |
| Mean | 6838.030941 |
| MAD | 4842.299734 |
| Skewness | 1.945147604 |
| Sum | 38477600.11 |
| Variance | 43769588.37 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 269.6 3712.41 3762.785 6618.16 ... 20942.94 25500.07 30381.01 37850.88 51745.45 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 16 | 0.3% | |
| 2229.21 | 2 | < 0.1% | |
| 3643.22 | 2 | < 0.1% | |
| 1016.1 | 2 | < 0.1% | |
| 765.7 | 2 | < 0.1% | |
| 1760.64 | 2 | < 0.1% | |
| 5938.71 | 2 | < 0.1% | |
| 2235.36 | 2 | < 0.1% | |
| 3384.96 | 2 | < 0.1% | |
| 1652.44 | 2 | < 0.1% | |
| Other values (5588) | 5593 | 99.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 16 | 0.3% | |
| 33.73 | 1 | < 0.1% | |
| 35.71 | 1 | < 0.1% | |
| 44.92 | 2 | < 0.1% | |
| 44.96 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51745.45 | 1 | < 0.1% | |
| 46850.28 | 1 | < 0.1% | |
| 45455.21 | 1 | < 0.1% | |
| 44517.49 | 1 | < 0.1% | |
| 44398.37 | 1 | < 0.1% |
total_pymnt_inv
Highly correlated
This variable is highly correlated with total_pymnt and should be ignored for analysis
| Correlation | 0.9680389296 |
|---|
total_rec_int
Numeric
| Distinct count | 5514 |
|---|---|
| Unique (%) | 98.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2194.459385 |
|---|---|
| Minimum | 0 |
| Maximum | 22122.3 |
| Zeros (%) | 1.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 126.886 |
| Q1 | 555.01 |
| Median | 1288.26 |
| Q3 | 2801.615 |
| 95-th percentile | 7526.193 |
| Maximum | 22122.3 |
| Range | 22122.3 |
| Interquartile range | 2246.605 |
Descriptive statistics
| Standard deviation | 2551.97393 |
|---|---|
| Coef of variation | 1.162916911 |
| Kurtosis | 8.652799913 |
| Mean | 2194.459385 |
| MAD | 1777.60752 |
| Skewness | 2.497958742 |
| Sum | 12348222.96 |
| Variance | 6512570.938 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.000000e+00 5.615000e+00 4.188500e+01 8.612700e+02 1.372985e+03 ... 8.091305e+03 9.959300e+03 1.162114e+04 1.635816e+04 2.212230e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 71 | 1.3% | |
| 696.99 | 2 | < 0.1% | |
| 1031.52 | 2 | < 0.1% | |
| 4874.16 | 2 | < 0.1% | |
| 1988.52 | 2 | < 0.1% | |
| 876.86 | 2 | < 0.1% | |
| 58.29 | 2 | < 0.1% | |
| 393.91 | 2 | < 0.1% | |
| 802.28 | 2 | < 0.1% | |
| 201.45 | 2 | < 0.1% | |
| Other values (5504) | 5538 | 98.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 71 | 1.3% | |
| 11.23 | 1 | < 0.1% | |
| 12.18 | 1 | < 0.1% | |
| 12.96 | 1 | < 0.1% | |
| 13.12 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22122.3 | 1 | < 0.1% | |
| 20909.99 | 1 | < 0.1% | |
| 20610.17 | 1 | < 0.1% | |
| 20071.29 | 1 | < 0.1% | |
| 19689.1 | 1 | < 0.1% |
total_rec_late_fee
Numeric
| Distinct count | 829 |
|---|---|
| Unique (%) | 14.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.291692071 |
|---|---|
| Minimum | 0 |
| Maximum | 180.2 |
| Zeros (%) | 84.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 29.9339491 |
| Maximum | 180.2 |
| Range | 180.2 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 12.81579047 |
|---|---|
| Coef of variation | 2.986185929 |
| Kurtosis | 31.10050694 |
| Mean | 4.291692071 |
| MAD | 7.271628859 |
| Skewness | 4.650905545 |
| Sum | 24149.35128 |
| Variance | 164.2444854 |
| Memory size | 44.0 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-03 1.46125000e+01 1.48406734e+01 1.48957949e+01 ... 4.49991212e+01 5.97644081e+01 5.99725363e+01 9.88194491e+01 1.80200000e+02], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 4764 | 84.7% | |
| 15 | 30 | 0.5% | |
| 30 | 4 | 0.1% | |
| 14.91923077 | 2 | < 0.1% | |
| 15.79 | 2 | < 0.1% | |
| 28.76 | 2 | < 0.1% | |
| 14.98772281 | 1 | < 0.1% | |
| 38.76688365 | 1 | < 0.1% | |
| 17.43148751 | 1 | < 0.1% | |
| 25.28224015 | 1 | < 0.1% | |
| Other values (819) | 819 | 14.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4764 | 84.7% | |
| 0.01 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 1.36 | 1 | < 0.1% | |
| 1.69 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 180.2 | 1 | < 0.1% | |
| 166.4297107 | 1 | < 0.1% | |
| 146.04 | 1 | < 0.1% | |
| 130.5970372 | 1 | < 0.1% | |
| 127.7878136 | 1 | < 0.1% |
total_rec_prncp
Highly correlated
This variable is highly correlated with total_pymnt and should be ignored for analysis
| Correlation | 0.9149544526 |
|---|
total_rev_hi_lim
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
url
URL
| Distinct count | 5627 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Value | Count | Frequency (%) | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=1017589 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=702018 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=748243 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=346656 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=839167 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=711812 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=834279 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=580015 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=985115 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=842558 | 1 | < 0.1% | |
| Other values (5617) | 5617 | 99.8% |
| Value | Count | Frequency (%) | |
| https | 5627 | 100.0% |
| Value | Count | Frequency (%) | |
| lendingclub.com | 5627 | 100.0% |
| Value | Count | Frequency (%) | |
| /browse/loanDetail.action | 5627 | 100.0% |
| Value | Count | Frequency (%) | |
| loan_id=782177 | 1 | < 0.1% | |
| loan_id=983890 | 1 | < 0.1% | |
| loan_id=823368 | 1 | < 0.1% | |
| loan_id=894021 | 1 | < 0.1% | |
| loan_id=490446 | 1 | < 0.1% | |
| loan_id=727518 | 1 | < 0.1% | |
| loan_id=822504 | 1 | < 0.1% | |
| loan_id=498079 | 1 | < 0.1% | |
| loan_id=548705 | 1 | < 0.1% | |
| loan_id=745292 | 1 | < 0.1% | |
| Other values (5617) | 5617 | 99.8% |
| Value | Count | Frequency (%) | |
| 5627 | 100.0% |
verification_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Not Verified | |
|---|---|
| Verified | |
| Source Verified |
| Value | Count | Frequency (%) | |
| Not Verified | 2142 | 38.1% | |
| Verified | 2051 | 36.4% | |
| Source Verified | 1434 | 25.5% |
| Max length | 15 |
|---|---|
| Mean length | 11.30655767 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
verification_status_joint
Constant
This variable is constant and should be ignored for analysis
| Constant value | None |
|---|
zip_code
Categorical
| Distinct count | 666 |
|---|---|
| Unique (%) | 11.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 945xx | 80 |
|---|---|
| 917xx | 71 |
| 100xx | 70 |
| Other values (663) |
| Value | Count | Frequency (%) | |
| 945xx | 80 | 1.4% | |
| 917xx | 71 | 1.3% | |
| 100xx | 70 | 1.2% | |
| 331xx | 70 | 1.2% | |
| 926xx | 67 | 1.2% | |
| 070xx | 65 | 1.2% | |
| 112xx | 65 | 1.2% | |
| 891xx | 64 | 1.1% | |
| 900xx | 64 | 1.1% | |
| 300xx | 52 | 0.9% | |
| Other values (656) | 4959 | 88.1% |
| Max length | 5 |
|---|---|
| Mean length | 5 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
First rows
| acc_now_delinq | acc_open_past_24mths | addr_state | all_util | annual_inc | annual_inc_joint | application_type | avg_cur_bal | bc_open_to_buy | bc_util | chargeoff_within_12_mths | collection_recovery_fee | collections_12_mths_ex_med | delinq_2yrs | delinq_amnt | desc | dti | dti_joint | earliest_cr_line | emp_length | emp_title | funded_amnt | funded_amnt_inv | grade | home_ownership | id | il_util | initial_list_status | inq_fi | inq_last_12m | inq_last_6mths | installment | int_rate | issue_d | last_credit_pull_d | last_pymnt_amnt | last_pymnt_d | loan_amnt | loan_status | max_bal_bc | member_id | mo_sin_old_il_acct | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | mths_since_last_delinq | mths_since_last_major_derog | mths_since_last_record | mths_since_rcnt_il | mths_since_recent_bc | mths_since_recent_bc_dlq | mths_since_recent_inq | mths_since_recent_revol_delinq | next_pymnt_d | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_120dpd_2m | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | open_acc | open_acc_6m | open_il_12m | open_il_24m | open_il_6m | open_rv_12m | open_rv_24m | out_prncp | out_prncp_inv | pct_tl_nvr_dlq | percent_bc_gt_75 | policy_code | pub_rec | pub_rec_bankruptcies | purpose | pymnt_plan | recoveries | revol_bal | revol_util | sub_grade | tax_liens | term | title | tot_coll_amt | tot_cur_bal | tot_hi_cred_lim | total_acc | total_bal_ex_mort | total_bal_il | total_bc_limit | total_cu_tl | total_il_high_credit_limit | total_pymnt | total_pymnt_inv | total_rec_int | total_rec_late_fee | total_rec_prncp | total_rev_hi_lim | url | verification_status | verification_status_joint | zip_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | None | GA | None | 30000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 1.1100 | 0.0 | 0 | 0 | Borrower added on 12/22/11 > I plan to use t... | 1.00 | None | Apr-99 | < 1 year | Ryder | 2500 | 2500.0 | C | RENT | 1077430 | None | f | None | None | 5 | 59.83 | 15.27% | Dec-11 | Sep-13 | 119.66 | Apr-13 | 2500 | Charged Off | None | 1314167 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 3 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | car | n | 117.08 | 1687 | 9.40% | C4 | 0.0 | 60 months | bike | None | None | None | 4 | None | None | None | None | None | 1008.71 | 1008.71 | 435.17 | 0.0 | 456.46 | None | https://lendingclub.com/browse/loanDetail.acti... | Source Verified | None | 309xx |
| 1 | 0 | None | CA | None | 40000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 2.0900 | 0.0 | 0 | 0 | Borrower added on 12/21/11 > I own a small h... | 5.55 | None | Apr-04 | 4 years | None | 5600 | 5600.0 | F | OWN | 1071795 | None | f | None | None | 2 | 152.39 | 21.28% | Dec-11 | Aug-12 | 152.39 | Apr-12 | 5600 | Charged Off | None | 1306957 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 11 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | small_business | n | 189.06 | 5210 | 32.60% | F2 | 0.0 | 60 months | Expand Business & Buy Debt Portfolio | None | None | None | 13 | None | None | None | None | None | 646.02 | 646.02 | 294.94 | 0.0 | 162.02 | None | https://lendingclub.com/browse/loanDetail.acti... | Source Verified | None | 958xx |
| 2 | 0 | None | TX | None | 15000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 2.5200 | 0.0 | 0 | 0 | Borrower added on 12/16/11 > I'm trying to b... | 18.08 | None | Sep-04 | < 1 year | Starbucks | 5375 | 5350.0 | B | RENT | 1071570 | None | f | None | None | 0 | 121.45 | 12.69% | Dec-11 | Mar-13 | 121.45 | Nov-12 | 5375 | Charged Off | None | 1306721 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | other | n | 269.29 | 9279 | 36.50% | B5 | 0.0 | 60 months | Building my credit history. | None | None | None | 3 | None | None | None | None | None | 1476.19 | 1469.34 | 533.42 | 0.0 | 673.48 | None | https://lendingclub.com/browse/loanDetail.acti... | Verified | None | 774xx |
| 3 | 0 | None | VA | None | 30000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 4.1600 | 0.0 | 0 | 0 | Borrower added on 12/15/11 > Plan to pay off... | 10.08 | None | Apr-04 | < 1 year | Va. Dept of Conservation/Recreation | 9000 | 9000.0 | C | RENT | 1064687 | None | f | None | None | 1 | 305.38 | 13.49% | Dec-11 | Nov-12 | 305.38 | Jul-12 | 9000 | Charged Off | None | 1298717 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 4 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | debt_consolidation | n | 444.30 | 10452 | 91.70% | C1 | 0.0 | 36 months | freedom | None | None | None | 9 | None | None | None | None | None | 2270.70 | 2270.70 | 570.26 | 0.0 | 1256.14 | None | https://lendingclub.com/browse/loanDetail.acti... | Source Verified | None | 245xx |
| 4 | 0 | None | CA | None | 100000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 6.3145 | 0.0 | 0 | 0 | None | 7.06 | None | May-91 | 3 years | SFMTA | 10000 | 10000.0 | B | RENT | 1069057 | None | f | None | None | 2 | 325.74 | 10.65% | Dec-11 | Mar-14 | 325.74 | Oct-13 | 10000 | Charged Off | None | 1303503 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 14 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | other | n | 645.10 | 11997 | 55.50% | B2 | 0.0 | 36 months | Other Loan | None | None | None | 29 | None | None | None | None | None | 7471.99 | 7471.99 | 1393.42 | 0.0 | 5433.47 | None | https://lendingclub.com/browse/loanDetail.acti... | Source Verified | None | 951xx |
| 5 | 0 | None | FL | None | 105000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 0.0000 | 0.0 | 0 | 0 | Borrower added on 12/16/11 > Decided to clea... | 13.22 | None | Feb-83 | 10+ years | Osram Sylvania | 21000 | 21000.0 | B | RENT | 1039153 | None | f | None | None | 0 | 701.73 | 12.42% | Dec-11 | May-16 | 701.73 | Sep-13 | 21000 | Charged Off | None | 1269083 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 7 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | debt_consolidation | n | 0.00 | 32135 | 90.30% | B4 | 0.0 | 36 months | Debt Cleanup | None | None | None | 38 | None | None | None | None | None | 14025.40 | 14025.40 | 3330.44 | 0.0 | 10694.96 | None | https://lendingclub.com/browse/loanDetail.acti... | Verified | None | 335xx |
| 6 | 0 | None | CA | None | 76000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 2.5700 | 0.0 | 0 | 0 | None | 2.40 | None | Jun-01 | 1 year | bmg-educational | 6000 | 6000.0 | B | RENT | 1069559 | None | f | None | None | 1 | 198.46 | 11.71% | Dec-11 | Mar-13 | 198.46 | Oct-12 | 6000 | Charged Off | None | 1304634 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 7 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | major_purchase | n | 269.31 | 5963 | 29.70% | B3 | 0.0 | 36 months | cash | None | None | None | 7 | None | None | None | None | None | 2050.14 | 2050.14 | 475.25 | 0.0 | 1305.58 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 900xx |
| 7 | 0 | None | NY | None | 60000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 0.0000 | 0.0 | 0 | 0 | Borrower added on 12/15/11 > looking to cons... | 15.22 | None | Oct-03 | 9 years | nyc transit | 15000 | 8725.0 | C | RENT | 1069800 | None | f | None | None | 1 | 514.64 | 14.27% | Dec-11 | May-16 | 0.00 | None | 15000 | Charged Off | None | 1304679 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 7 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | debt_consolidation | n | 0.00 | 5872 | 57.60% | C2 | 0.0 | 36 months | consolidation | None | None | None | 11 | None | None | None | None | None | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 103xx |
| 8 | 0 | None | PA | None | 50004.0 | None | INDIVIDUAL | None | None | None | 0.0 | 2.3000 | 0.0 | 3 | 0 | Borrower added on 12/16/11 > I have a stable... | 13.97 | None | Oct-03 | 2 years | Frito Lay | 5000 | 5000.0 | D | RENT | 1069657 | None | f | None | None | 0 | 123.65 | 16.77% | Dec-11 | May-13 | 123.65 | Dec-12 | 5000 | Charged Off | None | 1304764 | None | None | None | None | None | 20.0 | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 14 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | other | n | 260.96 | 4345 | 59.50% | D2 | 0.0 | 60 months | Other | None | None | None | 22 | None | None | None | None | None | 1609.12 | 1609.12 | 719.11 | 0.0 | 629.05 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 150xx |
| 9 | 0 | None | OH | None | 100000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 1.0700 | 0.0 | 0 | 0 | None | 16.33 | None | Jun-95 | 10+ years | STERIS Corporation | 5000 | 5000.0 | A | MORTGAGE | 1069465 | None | f | None | None | 0 | 158.77 | 8.90% | Dec-11 | Dec-14 | 158.77 | Aug-14 | 5000 | Charged Off | None | 1304521 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 17 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | 0.0 | debt_consolidation | n | 107.00 | 74351 | 62.10% | A5 | 0.0 | 36 months | Debt Consolidation for a better life | None | None | None | 35 | None | None | None | None | None | 5021.37 | 5021.37 | 696.99 | 0.0 | 4217.38 | None | https://lendingclub.com/browse/loanDetail.acti... | Source Verified | None | 441xx |
Last rows
| acc_now_delinq | acc_open_past_24mths | addr_state | all_util | annual_inc | annual_inc_joint | application_type | avg_cur_bal | bc_open_to_buy | bc_util | chargeoff_within_12_mths | collection_recovery_fee | collections_12_mths_ex_med | delinq_2yrs | delinq_amnt | desc | dti | dti_joint | earliest_cr_line | emp_length | emp_title | funded_amnt | funded_amnt_inv | grade | home_ownership | id | il_util | initial_list_status | inq_fi | inq_last_12m | inq_last_6mths | installment | int_rate | issue_d | last_credit_pull_d | last_pymnt_amnt | last_pymnt_d | loan_amnt | loan_status | max_bal_bc | member_id | mo_sin_old_il_acct | mo_sin_old_rev_tl_op | mo_sin_rcnt_rev_tl_op | mo_sin_rcnt_tl | mort_acc | mths_since_last_delinq | mths_since_last_major_derog | mths_since_last_record | mths_since_rcnt_il | mths_since_recent_bc | mths_since_recent_bc_dlq | mths_since_recent_inq | mths_since_recent_revol_delinq | next_pymnt_d | num_accts_ever_120_pd | num_actv_bc_tl | num_actv_rev_tl | num_bc_sats | num_bc_tl | num_il_tl | num_op_rev_tl | num_rev_accts | num_rev_tl_bal_gt_0 | num_sats | num_tl_120dpd_2m | num_tl_30dpd | num_tl_90g_dpd_24m | num_tl_op_past_12m | open_acc | open_acc_6m | open_il_12m | open_il_24m | open_il_6m | open_rv_12m | open_rv_24m | out_prncp | out_prncp_inv | pct_tl_nvr_dlq | percent_bc_gt_75 | policy_code | pub_rec | pub_rec_bankruptcies | purpose | pymnt_plan | recoveries | revol_bal | revol_util | sub_grade | tax_liens | term | title | tot_coll_amt | tot_cur_bal | tot_hi_cred_lim | total_acc | total_bal_ex_mort | total_bal_il | total_bc_limit | total_cu_tl | total_il_high_credit_limit | total_pymnt | total_pymnt_inv | total_rec_int | total_rec_late_fee | total_rec_prncp | total_rev_hi_lim | url | verification_status | verification_status_joint | zip_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5617 | 0 | None | FL | None | 70000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 1.04 | 0.0 | 1 | 0 | I'm looking to pay off a high interest credit ... | 10.20 | None | Oct-97 | 9 years | Equality Florida | 8000 | 150.0 | D | MORTGAGE | 127830 | None | f | None | None | 0 | 266.37 | 12.17% | Sep-07 | May-10 | 266.37 | Dec-09 | 8000 | Charged Off | None | 127824 | None | None | None | None | None | 22.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 15 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | credit_card | n | 102.910000 | 26283 | 39.50% | D2 | 0.0 | 36 months | Interest Rate | None | None | None | 20 | None | None | None | None | None | 7294.650000 | 136.40 | 1474.29 | 0.00 | 5717.45 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 337xx |
| 5618 | 0 | None | NC | None | 96000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 444.25 | 0.0 | 0 | 0 | I would like to increase advertising through y... | 16.89 | None | Jul-96 | < 1 year | None | 2125 | 550.0 | F | MORTGAGE | 127472 | None | f | None | None | 0 | 73.68 | 15.01% | Sep-07 | May-16 | 73.68 | Mar-09 | 2125 | Charged Off | None | 127460 | None | None | None | None | None | 46.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 5 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | small_business | n | 1254.398838 | 51 | 0% | F1 | 0.0 | 36 months | Expanding Business | None | None | None | 9 | None | None | None | None | None | 2580.248838 | 666.85 | 382.27 | 0.00 | 943.58 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 282xx |
| 5619 | 0 | None | MA | None | 15000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 0.00 | 0.0 | 0 | 0 | I am starting my own small business. I am a re... | 12.24 | None | Feb-04 | < 1 year | Tripolitan Films | 3175 | 1425.0 | C | OWN | 123230 | None | f | None | None | 3 | 104.76 | 11.54% | Aug-07 | Apr-16 | 104.76 | Mar-08 | 3175 | Charged Off | None | 80353 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 16 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | small_business | n | 0.000000 | 2867 | 55.10% | C5 | 0.0 | 36 months | Young Entrepreneur Needs Computer | None | None | None | 17 | None | None | None | None | None | 628.190000 | 281.80 | 172.24 | 0.00 | 455.95 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 015xx |
| 5620 | 0 | None | NY | None | 96000.0 | None | INDIVIDUAL | None | None | None | 0.0 | 0.00 | 0.0 | 0 | 0 | A bit about me: I have a master's in math from... | 2.86 | None | Aug-01 | < 1 year | UDFI | 20000 | 975.0 | B | RENT | 123228 | None | f | None | None | 0 | 642.02 | 9.64% | Sep-07 | May-16 | 642.02 | May-09 | 20000 | Charged Off | None | 120995 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 4 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | small_business | n | 0.000000 | 10296 | 42.50% | B4 | 0.0 | 36 months | I am expanding my business. | None | None | None | 8 | None | None | None | None | None | 12838.440000 | 624.61 | 2442.88 | 0.00 | 10395.56 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 112xx |
| 5621 | 0 | None | VA | None | 40000.0 | None | INDIVIDUAL | None | None | None | NaN | 3.09 | NaN | 0 | 0 | Thank you for reviewing my request. This loan... | 13.50 | None | Nov-92 | 2 years | ARIN | 15450 | 600.0 | C | MORTGAGE | 119043 | None | f | None | None | 3 | 507.46 | 11.22% | Aug-07 | Mar-10 | 1016.15 | Oct-09 | 15450 | Charged Off | None | 119040 | None | None | None | None | None | 54.0 | None | 111.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 13 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 1 | 1.0 | debt_consolidation | n | 304.200000 | 6513 | 34.30% | C4 | 0.0 | 36 months | paying credit cards and doctor bill. | None | None | None | 29 | None | None | None | None | None | 11652.750000 | 451.73 | 2659.96 | 0.00 | 8688.59 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 201xx |
| 5622 | 0 | None | NE | None | 32000.0 | None | INDIVIDUAL | None | None | None | NaN | 0.38 | NaN | 0 | 0 | Working on fixing my kitchen. I would like to ... | 20.00 | None | Jul-92 | < 1 year | Nebraska Occupational Therapy | 2500 | 675.0 | D | MORTGAGE | 118823 | None | f | None | None | 1 | 84.00 | 12.80% | Aug-07 | May-16 | 1.76 | Mar-10 | 2500 | Charged Off | None | 118026 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 11 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | home_improvement | n | 35.700000 | 3408 | 35.10% | D4 | 0.0 | 36 months | Need to put in new countertops. | None | None | None | 32 | None | None | None | None | None | 2220.610000 | 599.28 | 477.21 | 1.69 | 1706.01 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 685xx |
| 5623 | 0 | None | NE | None | 75000.0 | None | INDIVIDUAL | None | None | None | NaN | 0.00 | NaN | 0 | 0 | Putting in a new shower and fixtures. | 20.00 | None | Feb-94 | < 1 year | AMZ Marketing | 2500 | 825.0 | B | MORTGAGE | 118533 | None | f | None | None | 3 | 80.26 | 9.64% | Aug-07 | May-16 | 1.40 | Mar-10 | 2500 | Charged Off | None | 117783 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 9 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | home_improvement | n | 0.000000 | 269 | 3.80% | B4 | 0.0 | 36 months | re-model bathroom | None | None | None | 35 | None | None | None | None | None | 2086.630000 | 688.35 | 354.44 | 1.36 | 1730.83 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 685xx |
| 5624 | 0 | None | GA | None | 213000.0 | None | INDIVIDUAL | None | None | None | NaN | 0.00 | NaN | 0 | 0 | Used to continue to grow CollegeClassifieds.co... | 6.45 | None | Jul-90 | 9 years | Universal Advertising | 6500 | 225.0 | F | MORTGAGE | 118523 | None | f | None | None | 0 | 225.37 | 15.01% | Aug-07 | May-16 | 225.37 | Feb-09 | 6500 | Charged Off | None | 118519 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 11 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | small_business | n | 0.000000 | 56411 | 75.30% | F1 | 0.0 | 36 months | Business Financing Aug 2007 | None | None | None | 28 | None | None | None | None | None | 4054.350000 | 139.42 | 1168.14 | 0.00 | 2886.21 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 300xx |
| 5625 | 0 | None | VA | None | 33990.0 | None | INDIVIDUAL | None | None | None | NaN | 0.23 | NaN | 0 | 0 | I am getting married in 2009. My fiancee and I... | 14.47 | None | Jul-04 | 2 years | Invision Power Services | 1000 | 950.0 | C | MORTGAGE | 113179 | None | f | None | None | 1 | 32.55 | 10.59% | Aug-07 | Oct-09 | 32.55 | May-09 | 1000 | Charged Off | None | 113093 | None | None | None | None | None | 0.0 | None | 0.0 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 9 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | wedding | n | 21.290000 | 4485 | 36.90% | C2 | 0.0 | 36 months | Wedding site deposit | None | None | None | 11 | None | None | None | None | None | 703.950000 | 668.87 | 138.64 | 0.00 | 544.02 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 245xx |
| 5626 | 0 | None | FL | None | 145000.0 | None | INDIVIDUAL | None | None | None | NaN | 0.00 | NaN | 0 | 0 | refinancing | 10.15 | None | Jan-96 | 6 years | Auto motors of miami | 20000 | 2800.0 | E | MORTGAGE | 111227 | None | f | None | None | 0 | 678.08 | 13.43% | Aug-07 | May-16 | 678.08 | Feb-10 | 20000 | Charged Off | None | 111223 | None | None | None | None | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 17 | None | None | None | None | None | None | 0.0 | 0.0 | None | None | 1 | 0 | NaN | credit_card | n | 0.000000 | 41674 | 74.10% | E1 | NaN | 36 months | refinancing | None | None | None | 26 | None | None | None | None | None | 20339.660000 | 2845.82 | 4262.24 | 0.00 | 16077.42 | None | https://lendingclub.com/browse/loanDetail.acti... | Not Verified | None | 331xx |